

ALTER TABLE KULLANICILAR ADD INDIRIM "smalint" 		;@


ALTER TABLE RECETELER ADD PLU_NO "integer" 			;@
CREATE INDEX IDX_RECETELER3 ON RECETELER (PLU_NO)		;@


CREATE TABLE REZERVASYON (MASA_NO "smalint" NOT NULL )			;@
ALTER TABLE REZERVASYON ADD TARIH "date"					;@
ALTER TABLE REZERVASYON ADD SAAT "time"					;@
ALTER TABLE REZERVASYON ADD ISIM "varchar 060" COLLATE PXW_TURK 		;@
ALTER TABLE REZERVASYON ADD TEL_1 "varchar 025" COLLATE PXW_TURK 		;@
ALTER TABLE REZERVASYON ADD TEL_2 "varchar 025" COLLATE PXW_TURK 		;@
ALTER TABLE REZERVASYON ADD KISI "smalint"					;@
ALTER TABLE REZERVASYON ADD ACIKLAMA "varchar 250" COLLATE PXW_TURK	;@

CREATE TABLE DATA_Y (MASA_NO "integer" NOT NULL )			;@
ALTER TABLE DATA_Y ADD PRN_HESAP "smalint"	 			;@
alter table DATA_Y add constraint PK_DATA_Y primary key (MASA_NO)	;@


alter table DATA add PAKET VARCHAR (250) CHARACTER SET WIN1254 COLLATE PXW_TURK 	;@
alter table DATA add KISI_SAYISI "smalint"	 					;@


ALTER TABLE YEDEK_RAPOR ADD PLU_NO "integer" 	;@
ALTER TABLE YEDEK_RAPOR ADD RECETE_ID "integer" 	;@
ALTER TABLE YEDEK_RAPOR ADD REEL TIMESTAMP 	;@
ALTER TABLE YEDEK_RAPOR ADD ISLEM_KOD "integer" 	;@
ALTER TABLE YEDEK_RAPOR ADD SATIS_KOD "integer" 	;@
ALTER TABLE YEDEK_RAPOR ADD SUBE_ID "integer"	;@
ALTER TABLE YEDEK_RAPOR ADD KISI_SAYISI "smalint"	;@

ALTER TABLE DETAIL ADD REEL TIMESTAMP 		;@


ALTER TABLE DEPARTMAN ADD KDV "double" 		;@
ALTER TABLE DEPARTMAN ADD TUT "double"		;@


DROP VIEW  V_CK			;@
DROP VIEW  V_DENGE 		;@
DROP VIEW  V_EVRAK 		;@
DROP VIEW  V_FATURA 		;@
DROP VIEW  V_KASA		;@
DROP VIEW  V_RP 			;@
DROP VIEW  V_STOK 		;@


DROP PROCEDURE P_MYCELL		;@
DROP PROCEDURE RP 		;@
DROP PROCEDURE RP_1 		;@
DROP PROCEDURE CARI_TOP 	;@
DROP PROCEDURE RP_MASA 		;@


CREATE GENERATOR GEN_PLU ;@
-- SET GENERATOR GEN_PLU TO 2000 ;@


ALTER TABLE STOK ADD ISKNT0_1 "double" 	;@
ALTER TABLE STOK ADD ISKNT0_2 "double" 	;@
ALTER TABLE STOK ADD TIP "smalint" 		;@
ALTER TABLE STOK ADD ISKNT0_3 "double" 	;@
ALTER TABLE STOK ADD ISKNT0_4 "double" 	;@
ALTER TABLE STOK ADD ISKNT0_5 "double" 	;@
ALTER TABLE STOK ADD ISKNT0_6 "double" 	;@
ALTER TABLE STOK ADD MIKTARI 	 	COMPUTED BY (TIP*MIKTAR)  ;@
ALTER TABLE STOK ADD TUTARI 	 	COMPUTED BY (TIP*(FIYAT*MIKTAR))  	;@
ALTER TABLE STOK ADD ISKONTOLU_1 	COMPUTED BY (TIP*((FIYAT*MIKTAR)-(FIYAT*MIKTAR/100*ISKNT0_1)))  ;@
ALTER TABLE STOK ADD ISKONTOLU_2 	COMPUTED BY ( ISKONTOLU_1 - (TIP*(ISKONTOLU_1/100*ISKNT0_2)) )  ;@
ALTER TABLE STOK ADD SUBE_KODU "integer" DEFAULT 10001 NOT NULL 		;@
ALTER TABLE STOK ADD PLU_NO "integer"					;@



ALTER TABLE CK ADD D1 COMPUTED BY 
(CASE WHEN HESAP_TUTAR_BIRIMI= (select para from doviz_kurlari WHERE sira=1) THEN HESAP_TUTARI ELSE 0 END) ;@
ALTER TABLE CK ADD D2 COMPUTED BY 
(CASE WHEN HESAP_TUTAR_BIRIMI= (select para from doviz_kurlari WHERE sira=2) THEN HESAP_TUTARI ELSE 0 END) ;@
ALTER TABLE CK ADD D3 COMPUTED BY 
(CASE WHEN HESAP_TUTAR_BIRIMI= (select para from doviz_kurlari WHERE sira=3) THEN HESAP_TUTARI ELSE 0 END) ;@
ALTER TABLE CK ADD D4 COMPUTED BY 
(CASE WHEN HESAP_TUTAR_BIRIMI= (select para from doviz_kurlari WHERE sira=4) THEN HESAP_TUTARI ELSE 0 END) ;@
ALTER TABLE CK ADD D5 COMPUTED BY 
(CASE WHEN HESAP_TUTAR_BIRIMI= (select para from doviz_kurlari WHERE sira=5) THEN HESAP_TUTARI ELSE 0 END) ;@
ALTER TABLE CK ADD SUBE_KODU "integer" DEFAULT 10001 NOT NULL 		;@


CREATE TABLE SUBELER (SUBE "varchar 025" COLLATE PXW_TURK ) ;@
ALTER TABLE SUBELER ADD SUBE_KODU "integer" ;@


ALTER TABLE PDKS ADD ISLEM "smalint" ;@


ALTER TABLE URUNLER ADD PLU_NO "integer" 				;@
ALTER TABLE URUNLER ADD BARKOD_1 "varchar 025" COLLATE PXW_TURK 	;@
ALTER TABLE URUNLER ADD BARKOD_2 "varchar 025" COLLATE PXW_TURK 	;@
ALTER TABLE URUNLER ADD X_NO_1 "varchar 025" COLLATE PXW_TURK 	;@
ALTER TABLE URUNLER ADD X_NO_2 "varchar 025" COLLATE PXW_TURK 	;@
ALTER TABLE URUNLER ADD RECETE_ID "integer" 			;@
ALTER TABLE URUNLER ADD OZEL_MENU "smalint"			;@

-- alter table "URUNLER" drop "BIRIM_FIYATI_2" ;@


ALTER TABLE CARILER ADD RISK "double"  				;@
ALTER TABLE CARILER ADD TUTAR "double"  				;@
ALTER TABLE CARILER ADD KART_ID "varchar 025" COLLATE PXW_TURK 	;@


alter table KASALAR add "ISLEM" "smalint" 	;@
alter table KASALAR add "HESAP" "smalint" 	;@
alter table KASALAR add "POS" "smalint" 	;@
alter table KASALAR add "CEK" "smalint" 	;@
alter table KASALAR add "VADE" "smalint" 	;@
alter table KASALAR add "ORAN" "double" 	;@
alter table KASALAR add TARIH "varchar 025" COLLATE PXW_TURK    ;@


ALTER TABLE SIPARISLER ADD MIKTAR_2 "double" ;@


ALTER TABLE FK ALTER COLUMN A TYPE "double" ;@
ALTER TABLE FK ALTER COLUMN B TYPE "double" ;@
ALTER TABLE FK ALTER COLUMN C TYPE "double" ;@
ALTER TABLE FK ALTER COLUMN D TYPE "double" ;@
ALTER TABLE FK ALTER COLUMN E TYPE "double" ;@
ALTER TABLE FK ALTER COLUMN F TYPE "double" ;@


update RDB$FIELDS set  RDB$FIELD_TYPE = 27, RDB$FIELD_SCALE = 0, RDB$FIELD_PRECISION = 0  where RDB$FIELD_NAME = 'N (DEGER)' ;@

delete from RDB$GENERATORS where RDB$GENERATOR_NAME = 'GEN_SATIS_KODU' ;@

